﻿CREATE TABLE [dbo].[SalesMaster] (
    [SalesNo]        VARCHAR (30)    NOT NULL,
    [CustomerNo]     VARCHAR (8)     NOT NULL,
    [Dept]           INT             NULL,
    [ContractName]   VARCHAR (30)    NULL,
    [ContractNo]     VARCHAR (30)    NULL,
    [Warehouse]      INT             NULL,
    [Employee]       VARCHAR (20)    NULL,
    [ReceiveAccount] VARCHAR (30)    NULL,
    [ReceiveAmount]  NUMERIC (15, 2) NULL,
    [ReceiveDate]    DATETIME        NULL,
    [SalesDate]      DATETIME        NULL,
    [EntryDate]      DATETIME        NULL,
    [EntryEmployee]  VARCHAR (20)    NULL,
    [InvoiceNo]      VARCHAR (30)    NULL,
    [InvoiceDate]    DATETIME        NULL,
    [ShipFormNo]     VARCHAR (30)    NULL,
    [ShipDate]       DATETIME        NULL,
    [ReferenceNo]    VARCHAR (30)    NULL,
    [Remark]         VARCHAR (120)   NULL,
    [RecordID]       INT             IDENTITY (1, 1) NOT NULL
);

